#ifndef __QUERYACCOUNTINFO_H__
#define __QUERYACCOUNTINFO_H__

#include "dbmessage.h"

/**
*@file       queryaccount.h
*@brief      query account information verify user login
*
*@author     graywind
*@version    1.0.0.0
*@data       2012/03/27
*/

class QueryAccountInfo
{
    DeclareMysqlQueryPre(AccountDB);
};
ImplMysqlQueryPre(QueryAccountInfo, 
                  "select account_info.usr_id, role_info.role_code, role_info.name, role_info.level, role_info.job, role_info.gender, role_info.graphics, role_info.world  from account_info left join role_info on account_info.usr_name = '?' and account_info.usr_psw = '?' and account_info.usr_id = role_info.usr_id");

#endif